<?php
/**
 */
class REQ_LC_UNIVERSITYTable extends Doctrine_Table
{
	
	/**
	 * 
	 * @param $lc
	 * @return unknown_type
	 */
	public function getUniversityByLC($lc)
	{
		$q = $this->createQuery()
		->from('REQ_LC_UNIVERSITY LC_U')
		->leftjoin('LC_U.ID_REQ_UNIVERSITY')
		->where('LC_U.ID_REQ_LC = ?', $lc);
		
		return $q->execute(array(), Doctrine::HYDRATE_RECORD);	
	}
}